home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d3
/
dbasetut.arc
/
D509
< prev
next >
Wrap
Text File
|
1990-06-16
|
4KB
|
327 lines
*509010
C15,0
réü°Layout Fields Condition Update Exit
rüé≡┌ î─┬ ò─┬ û─┬ ö─┐
rüâ≡│Book.dbf ä │ PUBLISHER ï │YEAR ä
r╗â≡│CALLNUMBER
r╨â≡│
rüä≡╘ î═ ò═╪ û═╪ ö═╡
rçà╕ ç
rÄà≡│
rÅàÿ ò
rñà≡│ û │
r╝àâ ö
r╨à≡│
rççÅ
rèç▀ ä
rÄçÅ ö
róç▀
rúçÅ ô
r╢ç▀ ä
r║çÅ î
rçêÅ The next step in customizing the view is to order the ê
rçëÅ
rèë▀ Ä
rÿëÅ ô
r½ë▀ É
r╗ëÅ ï
rçèÅ fields in the view, the way you want them to appear. For à
rçïÅ
rëï▀ à
rÄïÅ ô
ríï▀
rúïÅ ô
r╢ï▀ ê
r╛ïÅ ê
rçîÅ this query
röîçYear
rÿîÅ should be to the left of
r▓îçTitle
r╖îÅ. Ä
rçìÅ ┐
rçÄÅ This is done in the view skeleton. ¢
rçÅÅ
rëÅ▀ à
rÄÅÅ ô
ríÅ▀
rúÅÅ ú
rçÉÅ Press
rÅÉ° F4
rôÉÅ to move the highlight to the view skeleton. ç
r╞É╕ å─┐
rçæÅ ö
r¢æ▀ ¬
r┼æÅ
r╠æ╕│
réÆÿ╓
râÆ≡View
rçÆÿ ê─╥ Å─┬ Å─┬ Å─┐
r╠Æ╕│
réôÿ║
râô≡Untitled
rÅôÿ║
rÉô≡Book->
rƒôÿ│
ráô≡Book->
r»ôÿ│
r░ô≡Book─>
r╢ôÿ ë │
r╠ô╕│
réöÿ║
rÅöÿ║
rÉö≡TITLE ä
rƒöÿ│
ráö≡YEAR ä
r»öÿ│
r░ö≡CALLNUMBER à
r┐öÿ│
r╠ö╕│
réòÿ╙ î─╨ Å─┴ Å─┴ Å─┘
d╠ò╕││
rüù·Query ║C:\dbase\samples\<NEW> ║Field: 6/6 è ║ î ║ ç
r╠ù╕│
r═ù· ä
rüÿ╪ Next/Prev field:Tab/Shift-Tab Data:F2 Pick:Shift-F1 Prev/
r┐ÿ°Next skel
r╚ÿ╪:F3/
r╠ÿ°F4
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H003E,,
a8,C,D002,,,&H003F,,
*509020
C3,0
r╝àÿ ò
r╞É° ç
r╠æ°
rÉÆâ Å
d╠Æ° à
r¬ù·1/3
r╠ù·
rüÿ╪ ç Remove from view:F5 Select:F6 Move:F7 Prev/Next skeleton:F3/F4 ç
q╧ÿ╪P,1,,,,,
a1,P,,,,,,
*509030
C11,7
rëê▀ ╖
rëè▀ ║
rëî▀ ▒
rëÄ▀ ú
rçÉ╪ ┐
rçæ╪ ┐
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509040
C1,7
rëêÅNow press
rôê° F7
rùêÅ the
r£êçMove
ráêÅ key, to highlight the
r╖êçTITLE
r╝êÅ field
rëèÅfor moving.
r¿╪°Move:F7
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509050
C15,0
r¿ÿ°Move:F7
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0041,,
a8,C,D002,,,&H003F,,
*509060
C14,0
rÅÆ≡ æ▒
rÅôÿ▒
rƒôÿ▒
rÅöÿ▒
rƒöÿ▒
rÅò≡ æ▒
rüÿ╪ Å TAB or SHIFT-TAB to move fields, ──┘ to complete Å
q╧ÿ╪P,1,,,,,
a1,P,,,,,,
*509070
C11,7
rëê▀ ╣
rëè▀ ï
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509080
C1,7
rëêÅWith the
rÆêçTitle
rùêÅ field selected, press TAB
r▓ê° ───│
r╣êÅ to move
rëèÅit to the right, then press
rÑè° ──┘
r½èÅ to complete the move.
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H09,,
a8,C,D002,,,&H003F,,
*509090
C3,0
rÅÆÿ╥ Å─
rƒÆ≡ æ▒
rÅôÿ║
r»ôÿ▒
rÅöÿ║
rÉö≡YEAR
ráö≡TITLE
r»öÿ▒
rÄòÿ─╨ Å─
ráò≡ É▒
r¬ù·2
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0D,,
a8,C,D002,,,&H003F,,
*509100
C3,0
r₧Æÿ─┬
ráÆâ Å
r»Æÿ┬─
rƒôÿ│
r»ôÿ│
rƒöÿ│
r»öÿ│
r₧òÿ─┴ Å─┴─
rêÿ╪Remove from view:F5 Select:F6 Move:F7 Prev/Next skeleton:F3/F4
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509110
C11,7
rëê▀ ╕
rëè▀ ╕
rüÿ╕ ╧
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509120
C1,7
rëêÅThe view query is now the way you want it.
rëèÅAs a final step, you will give it a description.
rëîÅPress
rÅî° Alt-L
rûîÅ to open the
rúîçLayout
r⌐îÅ menu.
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H0026,,
a8,C,D002,,,&H003F,,
*509130
C14,3
rüü≤ Layout
rüé≤╔ á═╗
rüâ≤║ Add file to query î ║
rüä≤║
réä° Remove file from query ç
róä≤║
rüà≤║
réà╕ á─
róà≤║
rüå≤║
réå╕ Create link by pointing å
róå≤║
rüç≤║
réç╕ á─
róç≤║
rüê≤║
réê° Write view as database file
róê≤║
rüë≤║
réë° Edit description of query ä
róë≤║
rüè≤║
réè° Save this query Ä
róè≤║
rüï≤╚ á═╝
rüÿ╕ ╧
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509140
C11,7
rúê▀ æ
rúè▀ û
rëî▀ ª
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509150
C1,7
rÑêÅPress
r½ê° E
r«êÅ to select
rÑèçEdit description of query
r╛èÅ.
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,P,,,,&H65,,
a8,P,,,,&H45,,
a8,C,D002,,,&H003F,,
*509160
C15,0
réâ° Add file to query î
réë≤ Edit description of query ä
råè√╔ ╞═╗
råï√║
rçïÿ ╞
r═ï√║
råî√║
rçîÿ Edit the description of this .qbe file ₧
r═î√║
råì√║
rçìÿ ╞
r═ì√║
råÄ√║
rçÄÿ
rëÄâ ┬
r╦Äÿ
r═Ä√║
råÅ√║
rçÅÿ ╞
r═Å√║
råÉ√╚ ╞═╝
qëÄâP,1,,,,,
a1,P,,,,,,
*509170
C1,7
rêçÅ ╛
rêêÅ ▒
rêëÅ Press
rÉë° ──┘
rûëÅ and the Introduction will type a description.
rêèÅ ╛
qëÄ╕S,,,,,,
a7,G,,,,,,
a8,P,,,,&H0D,,
a8,C,D002,,,&H003F,,
*509180
C0,3
rë«âYear, title, and call number of books published after 1985.
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509190
C11,7
rèë▀ ║
q╧ÿ╕P,1,,,,,
a1,P,,,,,,
*509200
C1,7
rèëÅPress
rÉë° ──┘
rûëÅ to save the description.
q╧ÿ╕S,,,,,,
QC1
a7,G,,,,,,
a8,C,D510,,,&H0D,,
a8,C,D002,,,&H003F,,